Aside

Data Tools & Languages

Additional Skills

Education

Double Bachelor of Arts in
Psychology & Philosophy

Victoria University of
Wellington

November, 2019

Wellington, NZ

Certification

Professional Certificate in Data Analytics

Google Careers Certification

June, 2021

Coursera

Disclaimer

Page 1 of 1

Main

Kyle PATRICK Simpson

ETL/ELT Pipeline Support Specialist   |   Researrch Analyst   |   Data Technician

Data analyst with 5+ years experience supporting data pipelines, automating workflows, and integrating datasets using SQL, Python, R, and Excel/Googlesheets. Strong focus on data quality, reporting accuracy, and translating complex data into operational decisions. Experience across Non-profit, Hospitality/Retail, Public Health, and Environmental Research sectors.

Relevant Work History

Inventory & Quality Assurance Analyst

M2 by Matcha Matcha

Toronto, Ont

2024

  • Developed an accurate inventory reporting system using R, SQL, and Excel/Google Sheets via triangulation of sales, purchasing, and inventory records.
  • Maintained relational database of supplier, product, and customer information acquired via information requests, exported datasets, APIs, and web-scraping.
  • Facilitated working relationships with suppliers to ensure consistency of quality, supply, and pricing.

Data Migration Technician

Lions Foundation of Canada Dog Guides

Oakville, Ont

2022

  • Consulted on migration of 4 months financial and client data from Excel & Quickbooks into Salesforce.
  • Creation of automated workflows using VBA in Excel for the purpose of data compiling, cleaning, and validation.
  • Reached out to individual donor and/or members of the finance team to amend irregularities and/or obtain missing data as required.

Data & Systems Administrator

Accident Compensation Commission, NZ

Dunedin, NZ

2022 - 2021

  • Demonstrated ability to quickly learn NZ health care policy as it pertains to various work environments and accident coverage.
  • Researched and identified various employer entities to ensure accurate attribution of benefits.
  • Employed analytical skills to proactively identify and resolve system irregularities and errors.

Managing Director / Data Systems Consultant

Bar Squire Beverage Consultancy Services

Wellington, NZ

2021 - 2020

  • Provided data driven consultation to bars, restaurants, and events.
  • Creation and maintenance of relational databases containing client information, cocktail recipes, product information, bar & restaurant points of service.
  • Use of SQL, Excel, R, and Python to wrangle data.

Research Analyst

Greenback Ltd.

Auckland, NZ

2020 - 2019

  • Conducted thorough literature reviews of various subjects so as to educate myself and team members on relevant subject matter, data types, and stakeholders.
  • Identified various sources of private and publicly available environmental data via information requests, web-scraping, and API pulls.
  • Collaborated directly with the application development team on data implementation and structuring.